
<div class='part'>
<?php
include("calendar.php");
testcal();

include_once("connect.php");


$result=mysql_query("select * from ap3_sp_soins");
$soins=array();
while($c=mysql_fetch_assoc($result))
    $soins[$c['ID']]=$c['titre'];



$result=mysql_query("select * from ap3_sp_utilisateur");
$client=array();
while($c=mysql_fetch_assoc($result)){
    $client[$c['ID']]=$c['Nom'];
    $prenomclient[$c['ID']]=$c['Prenom'];
    }
$client['0']='administrateur';
$prenomclient['0']='';

$result=mysql_query("select * from ap3_sp_rdv where valide='NULL'");

echo "<br/><form action='valide_rdv.php' method='post'> ";
echo "<table id='validetab'>";
echo "<tr><td>date</td><td>heure</td><td>utilisateur</td><td>soin</td><td>valide</td><td>refuser</td></tr>";
while($rdv=mysql_fetch_assoc($result)){
  echo "<tr><td>".$rdv['dateRDV']."</td><td>".$rdv['heure']."</td><td>".$client[$rdv['client']]." ".$prenomclient[$rdv['client']]."</td><td>".$soins[$rdv['soinchoisi']]."</td><td><input type='checkbox' name='valide[]' value='".$rdv['ID']."'/></td><td><input type='checkbox' name='suppr[]' value='".$rdv['ID']."'/></td></tr>";
  echo "<tr><td></td><td colspan='5'>".$rdv['soin']."</td></tr> \n";

} 
?>
</table>
<input type='hidden' name='page' value='calendrier'/>
<input type="submit" value="Envoyer" />
</form>

</div>



